package com.web.exiaodao.business.repository;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.web.exiaodao.business.entity.ShopStandardValues;

import java.util.Collection;
import java.util.List;


public interface ShopStandardValuesRepository extends
		PagingAndSortingRepository<ShopStandardValues, Long>,
		JpaSpecificationExecutor<ShopStandardValues> {
	public ShopStandardValues findByIdAndStatusNot(Long id,Integer status);

	/**
	 * 查询该商品的所有规格;然后自己进行处理
	 * @param shopId
	 * @param status
	 * @return
	 */
	public List<ShopStandardValues> findByShopIdAndStatusNot(Long shopId, Integer status);

	/**
	 *
	 * @param shopStandsNameId 商品名称id
	 * @param status
	 * @return
	 */
	public List<ShopStandardValues> findByShopStandsNameIdAndStatusNot(Long shopStandsNameId, Integer status);


	public List<ShopStandardValues> findByIdInAndStatusNot(Collection<Long> id, Integer status);
}
